<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file="/common/common.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta charset="UTF-8"/>
    <title>余额记录列表</title>
    <link href="${ctx}/static/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
    <link href="${ctx}/static/dist/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
    <link href="${ctx}/static/plugins/datatables/css/matrix-style.css" rel="stylesheet" type="text/css" />
    <link href="${ctx}/static/dist/css/AdminLTE.css" rel="stylesheet" type="text/css" />
    <link href="${ctx}/static/plugins/datatables/css/dataTables.bootstrap.css" rel="stylesheet" type="text/css" />
    <style>
        button.searching{
            background-color:#666
        }
    </style>
</head>
<body>
<div class="widget-box">
	<div class="widget-title">
	   <h5>请输入查询条件</h5>
	</div>
	<div class="widget-content nopadding">
		<table style="line-height:45px;font-size:12px;">
			<tr>
				<td>&nbsp;&nbsp;&nbsp;来源：</td>
				<td>
				<select name="source" id="source" class="form-control">   
			        <option value="-1" selected="selected">全部</option>    
			        <option value="1">充值</option>   
			        <option value="2">提现</option>   
			        <option value="3">分润</option>   
			        <option value="4">线上订单</option>   
			        <option value="5">线下订单</option>    
			        <option value="6">进货</option>   
			        <option value="7">线下代付</option>   
			      </select>
				</td>
				<td>&nbsp;&nbsp;&nbsp;状态：</td>
				<td>
				<select name="status" id="status" class="form-control">   
			        <option value="-1" selected="selected">全部</option>    
			        <option value="1">成功</option>   
			        <option value="2">操作中</option>   
			        <option value="3">失败</option>   
			      </select>
				</td>
				<td>&nbsp;&nbsp;&nbsp;供应商名称：</td>
				<td><input type="text" class="form-control" name="supplierName" id="supplierName"  style="width:200px;" placeholder="供应商名称" ></td>
			</tr>
			<tr>
                <td>&nbsp;&nbsp;&nbsp;时间：</td>
                <td><input type="text" class="form-control" name="startTime" id="startTime" style="width:200px;"
                         onClick="WdatePicker({dateFmt:'yyyy-MM-dd',alwaysUseStartDate:true})"   placeholder="开始时间"></td>
                <td>&nbsp;&nbsp;&nbsp;至：</td>
                <td><input type="text" class="form-control" name="endTime" id="endTime" style="width:200px;"
                         onClick="WdatePicker({dateFmt:'yyyy-MM-dd',alwaysUseStartDate:true})" placeholder="结束时间"></td>
                <td>
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a class="btn btn-success" href="#" onclick="query();">查 询</a>
                </td>
			</tr>
		</table>
	</div>
</div>
 <div class="row">
		 <div class="col-xs-12">
		 	<div class="box">
		 		<div class="box-header">
	                 <h3 class="box-title">余额记录列表</h3>
	             </div>
	             <!-- 列表 -->
	             <div class="box-body table-responsive">
	             	<table id="dataTables" class="table table-bordered table-hover">
	             	</table>
	             </div>
		 	</div>
		 </div>
	</div>
<script src="${ctx}/static/plugins/jQuery/jQuery-2.1.4.min.js"></script>
<script src="${ctx}/static/bootstrap/js/bootstrap.min.js"></script>
<!-- datatable -->
<script src="${ctx}/static/plugins/datatables/jquery.dataTables.js" type="text/javascript"></script>
<script src="${ctx}/static/plugins/datatables/dataTables.bootstrap.js" type="text/javascript"></script>
<!-- 时间选择 -->
<script src="${ctx}/static/js/common/time/WdatePicker.js" type="text/javascript"></script>
<script>
   var tb;
   $(function () {
		//列表初始化
		tb = $('#dataTables').dataTable({
				"bServerSide": true,
				"sPaginationType": "full_numbers",
				"bJQueryUI": true,
				"sDom": '<"">t<"F"ip>',
				"sAjaxSource": "${ctx}/api/supplier/balance", //ajax调用接口
				"aoColumnDefs": [{sDefaultContent: '',aTargets: [ '_all' ]}],
	       		"aoColumns": [
					  	{ "sTitle" : "序号", 	 "mData": "id" ,"class":"sClass"},
		                { "sTitle" : "供应商名称","mData": "supplierName","class":"sClass" },
		                { "sTitle" : "来源","mData": "source","class":"sClass" },
		                { "sTitle" : "订单号","mData": "orderNum","class":"sClass" },
		                { "sTitle" : "时间","mData": "createTime","class":"sClass","mRender":function(data, type, full){
	                    	if(full.createTime!='' && full.createTime!='null'){
			                	return (full.createTime).substring(0,(full.createTime).length-2);
	                    	}else{
	                    		return full.createTime;
	                    	}
		                	}
		                },
		                { "sTitle" : "金额","mData": "balance","class":"sClass" },
		                { "sTitle" : "手续费","mData": "fee","class":"sClass" },
		                { "sTitle" : "收入总额","mData": "amount","class":"sClass" },
		                { "sTitle" : "状态","mData": "status","class":"sClass","mRender":function(data, type, full){
		                	var text;
		                	if(full.status=='成功'){
		                        text="<font color='blue'>成功</font>";
		                    }else if(full.status=='操作中') {
		                        text="<font color='green'>操作中</font>"
		                    }else if(full.status=='失败') {
		                            text="<font color='red'>失败</font>"
		                    }
	                    	return text;
	        				}
		                },
		                { "sTitle" : "备注","mData": "remark","class":"sClass" }
	            ],
		        "oLanguage" : {
		           "sProcessing" : "数据加载中······",
		           "sLengthMenu" : "显示 _MENU_ 条记录",
		           "sZeroRecords" : "没有您要搜索的内容！",
		           "sEmptyTable" : "列表中无数据存在！",
		           "sInfo" : "当前显示 _START_ 到 _END_ 条数据，共 _TOTAL_ 条数据",
		           "sInfoEmpty" : "显示 0 到 0 条记录",
		           "sInfoFiltered" : "数据列表中共  _MAX_ 条记录",
		           "oPaginate" : {
		               "sFirst" : "首页",
		               "sPrevious" : "上一页",
		               "sNext" : "下一页",
		               "sLast" : "末页"
		           }
		        },
		        "fnServerData" : function ( sSource, aoData, fnCallback, oSettings ) {
					oSettings.jqXHR = $.ajax( {
						"dataType" 	: 'json',
						"type" 		: "GET",
						"async"     : 'false',
						"url" 		: sSource,
						"data" 		: {
							'pageNum': (aoData[3].value/aoData[4].value)+1,
							'pageSize' :  aoData[4].value,
							'supplierName'  :  $("#supplierName").val(),
							'type' : 1,//设置type为供应商
	                        'startTime': $("#startTime").val(),
	                        'endTime': $("#endTime").val(),
	                        'source': $("select[name='source']").val(),
	                        'status': $("select[name='status']").val(),
						}, 
						"success"	: fnCallback
					} );
				},
		  });

   });
   
   //条件查询重新加载数据
   function query() {
	   var startTime = $("#startTime").val();
	   var endTime = $("#endTime").val();
	  if(startTime!=""&&endTime!=""&&!compareDate(startTime,endTime)){
		  alert("查询条件开始时间不能大于结束时间!");
		  return;
	  }
	  tb.fnDraw();
   };
   
   //时间比较
   function compareDate(DateOne, DateTwo) {
	   var OneMonth = DateOne.substring(5, DateOne.lastIndexOf("-"));
	   var OneDay = DateOne.substring(DateOne.length, DateOne.lastIndexOf("-") + 1);
	   var OneYear = DateOne.substring(0, DateOne.indexOf("-"));
	   var TwoMonth = DateTwo.substring(5, DateTwo.lastIndexOf("-"));
	   var TwoDay = DateTwo.substring(DateTwo.length, DateTwo.lastIndexOf("-") + 1);
	   var TwoYear = DateTwo.substring(0, DateTwo.indexOf("-"));
	   if (Date.parse(OneMonth + "/" + OneDay + "/" + OneYear) <= Date.parse(TwoMonth + "/" + TwoDay + "/" + TwoYear)) {
	     return true;
	   } else {
	     return false;
	   }
	 }
   
</script>
</body>
</html>